Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_CONTROLFILE_COPY

This view lists information about control file copies on disk. A datafile copy record with a file number of 0 represents the control file copy in `V$DATAFILE_COPY`.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY` | `NUMBER` | The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`CCF_KEY` | `NUMBER` | The primary key of the control file copy in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output.
`RECID` | `NUMBER` | The record identifier from `V$DATAFILE_COPY`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP` | `NUMBER` | The stamp from `V$DATAFILE_COPY`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`NAME` | `VARCHAR2(1024)` | The control file copy filename.
`TAG` | `VARCHAR2(32)` | The tag of the control file copy. `NULL` if no tag used.
`RESETLOGS_CHANGE#` | `NUMBER` | The SCN of the most recent `RESETLOGS` when the record was created.
`RESETLOGS_TIME` | `DATE` | The time stamp of the most recent `RESETLOGS` when the record was created.
`CHECKPOINT_CHANGE#` | `NUMBER` | The control file checkpoint SCN.
`CHECKPOINT_TIME` | `DATE` | The control file checkpoint time.
`CREATION_TIME` | `DATE` | The control file creation time.
`BLOCK_SIZE` | `NUMBER` | The block size in bytes.
`MIN_OFFR_RECID` | `NUMBER` | Internal use only.
`OLDEST_OFFLINE_RANGE` | `NUMBER` | Internal use only.
`COMPLETION_TIME` | `DATE` | The time when the copy was generated.
`STATUS` | `VARCHAR2(1)` | The status of the copy: `A` (available), `U` (unavailable), `X` (expired), or `D` (deleted).
`CONTROLFILE_TYPE` | `VARCHAR2(1)` | The type of control file copy: `B` (normal copy) or `S` (standby copy).
`KEEP` | `VARCHAR2(3)` | Indicates whether this copy has a retention policy different from the value for `CONFIGURE` `RETENTION` `POLICY`. Possible values are `YES` and `NO`.
`KEEP_UNTIL` | `DATE` | If the `KEEP` `UNTIL` `TIME` clause of the `COPY` command was specified, then this column shows the date after which this file becomes obsolete. If the column is `NULL` and `KEEP` `OPTIONS` is not `NULL`, the file never becomes obsolete.
`KEEP_OPTIONS` | `VARCHAR2(10)` | The `KEEP` options specified for this control file copy. Options can be `LOGS` (RMAN keeps the logs needed to recover this backup), `NOLOGS` (RMAN does not keep the logs needed to recover this backup), or `NULL` (the backup has no `KEEP` options and is subject to the default retention policy).
`IS_RECOVERY_DEST_FILE` | `VARCHAR2(3)` | This copy is located in the flash recovery area: `YES` or `NO`.